package com.zj.fx.model.auto;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import cn.hutool.core.util.StrUtil;

/**
 * 月度数据导入数据原始表 AutoOriimportExample
 * @author SQL_自动生成
 * @date 2024-02-26 09:55:53
 */
public class AutoOriimportExample {

    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public AutoOriimportExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        
            public Criteria andIdIsNull() {
                addCriterion("id is null");
                return (Criteria) this;
            }

            public Criteria andIdIsNotNull() {
                addCriterion("id is not null");
                return (Criteria) this;
            }

            public Criteria andIdEqualTo(String value) {
                addCriterion("id =", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotEqualTo(String value) {
                addCriterion("id <>", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdGreaterThan(String value) {
                addCriterion("id >", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdGreaterThanOrEqualTo(String value) {
                addCriterion("id >=", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdLessThan(String value) {
                addCriterion("id <", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdLessThanOrEqualTo(String value) {
                addCriterion("id <=", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdLike(String value) {
                addCriterion("id like", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotLike(String value) {
                addCriterion("id not like", value, "id");
                return (Criteria) this;
            }

            public Criteria andIdIn(List<String> values) {
                addCriterion("id in", values, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotIn(List<String> values) {
                addCriterion("id not in", values, "id");
                return (Criteria) this;
            }

            public Criteria andIdBetween(String value1, String value2) {
                addCriterion("id between", value1, value2, "id");
                return (Criteria) this;
            }

            public Criteria andIdNotBetween(String value1, String value2) {
                addCriterion("id not between", value1, value2, "id");
                return (Criteria) this;
            }

        
            public Criteria andSupplyIdIsNull() {
                addCriterion("supply_id is null");
                return (Criteria) this;
            }

            public Criteria andSupplyIdIsNotNull() {
                addCriterion("supply_id is not null");
                return (Criteria) this;
            }

            public Criteria andSupplyIdEqualTo(String value) {
                addCriterion("supply_id =", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdNotEqualTo(String value) {
                addCriterion("supply_id <>", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdGreaterThan(String value) {
                addCriterion("supply_id >", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdGreaterThanOrEqualTo(String value) {
                addCriterion("supply_id >=", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdLessThan(String value) {
                addCriterion("supply_id <", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdLessThanOrEqualTo(String value) {
                addCriterion("supply_id <=", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdLike(String value) {
                addCriterion("supply_id like", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdNotLike(String value) {
                addCriterion("supply_id not like", value, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdIn(List<String> values) {
                addCriterion("supply_id in", values, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdNotIn(List<String> values) {
                addCriterion("supply_id not in", values, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdBetween(String value1, String value2) {
                addCriterion("supply_id between", value1, value2, "supplyId");
                return (Criteria) this;
            }

            public Criteria andSupplyIdNotBetween(String value1, String value2) {
                addCriterion("supply_id not between", value1, value2, "supplyId");
                return (Criteria) this;
            }

        
            public Criteria andSupplyNameIsNull() {
                addCriterion("supply_name is null");
                return (Criteria) this;
            }

            public Criteria andSupplyNameIsNotNull() {
                addCriterion("supply_name is not null");
                return (Criteria) this;
            }

            public Criteria andSupplyNameEqualTo(String value) {
                addCriterion("supply_name =", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameNotEqualTo(String value) {
                addCriterion("supply_name <>", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameGreaterThan(String value) {
                addCriterion("supply_name >", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameGreaterThanOrEqualTo(String value) {
                addCriterion("supply_name >=", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameLessThan(String value) {
                addCriterion("supply_name <", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameLessThanOrEqualTo(String value) {
                addCriterion("supply_name <=", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameLike(String value) {
                addCriterion("supply_name like", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameNotLike(String value) {
                addCriterion("supply_name not like", value, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameIn(List<String> values) {
                addCriterion("supply_name in", values, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameNotIn(List<String> values) {
                addCriterion("supply_name not in", values, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameBetween(String value1, String value2) {
                addCriterion("supply_name between", value1, value2, "supplyName");
                return (Criteria) this;
            }

            public Criteria andSupplyNameNotBetween(String value1, String value2) {
                addCriterion("supply_name not between", value1, value2, "supplyName");
                return (Criteria) this;
            }

        
            public Criteria andSubcompanyIdIsNull() {
                addCriterion("subcompany_id is null");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdIsNotNull() {
                addCriterion("subcompany_id is not null");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdEqualTo(String value) {
                addCriterion("subcompany_id =", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdNotEqualTo(String value) {
                addCriterion("subcompany_id <>", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdGreaterThan(String value) {
                addCriterion("subcompany_id >", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdGreaterThanOrEqualTo(String value) {
                addCriterion("subcompany_id >=", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdLessThan(String value) {
                addCriterion("subcompany_id <", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdLessThanOrEqualTo(String value) {
                addCriterion("subcompany_id <=", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdLike(String value) {
                addCriterion("subcompany_id like", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdNotLike(String value) {
                addCriterion("subcompany_id not like", value, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdIn(List<String> values) {
                addCriterion("subcompany_id in", values, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdNotIn(List<String> values) {
                addCriterion("subcompany_id not in", values, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdBetween(String value1, String value2) {
                addCriterion("subcompany_id between", value1, value2, "subcompanyId");
                return (Criteria) this;
            }

            public Criteria andSubcompanyIdNotBetween(String value1, String value2) {
                addCriterion("subcompany_id not between", value1, value2, "subcompanyId");
                return (Criteria) this;
            }

        
            public Criteria andSubcompanyNameIsNull() {
                addCriterion("subcompany_name is null");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameIsNotNull() {
                addCriterion("subcompany_name is not null");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameEqualTo(String value) {
                addCriterion("subcompany_name =", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameNotEqualTo(String value) {
                addCriterion("subcompany_name <>", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameGreaterThan(String value) {
                addCriterion("subcompany_name >", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameGreaterThanOrEqualTo(String value) {
                addCriterion("subcompany_name >=", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameLessThan(String value) {
                addCriterion("subcompany_name <", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameLessThanOrEqualTo(String value) {
                addCriterion("subcompany_name <=", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameLike(String value) {
                addCriterion("subcompany_name like", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameNotLike(String value) {
                addCriterion("subcompany_name not like", value, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameIn(List<String> values) {
                addCriterion("subcompany_name in", values, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameNotIn(List<String> values) {
                addCriterion("subcompany_name not in", values, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameBetween(String value1, String value2) {
                addCriterion("subcompany_name between", value1, value2, "subcompanyName");
                return (Criteria) this;
            }

            public Criteria andSubcompanyNameNotBetween(String value1, String value2) {
                addCriterion("subcompany_name not between", value1, value2, "subcompanyName");
                return (Criteria) this;
            }

        
            public Criteria andTaskmonthIsNull() {
                addCriterion("taskmonth is null");
                return (Criteria) this;
            }

            public Criteria andTaskmonthIsNotNull() {
                addCriterion("taskmonth is not null");
                return (Criteria) this;
            }

            public Criteria andTaskmonthEqualTo(String value) {
                addCriterion("taskmonth =", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotEqualTo(String value) {
                addCriterion("taskmonth <>", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthGreaterThan(String value) {
                addCriterion("taskmonth >", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthGreaterThanOrEqualTo(String value) {
                addCriterion("taskmonth >=", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthLessThan(String value) {
                addCriterion("taskmonth <", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthLessThanOrEqualTo(String value) {
                addCriterion("taskmonth <=", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthLike(String value) {
                addCriterion("taskmonth like", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotLike(String value) {
                addCriterion("taskmonth not like", value, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthIn(List<String> values) {
                addCriterion("taskmonth in", values, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotIn(List<String> values) {
                addCriterion("taskmonth not in", values, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthBetween(String value1, String value2) {
                addCriterion("taskmonth between", value1, value2, "taskmonth");
                return (Criteria) this;
            }

            public Criteria andTaskmonthNotBetween(String value1, String value2) {
                addCriterion("taskmonth not between", value1, value2, "taskmonth");
                return (Criteria) this;
            }

        
            public Criteria andTypeMemoIsNull() {
                addCriterion("type_memo is null");
                return (Criteria) this;
            }

            public Criteria andTypeMemoIsNotNull() {
                addCriterion("type_memo is not null");
                return (Criteria) this;
            }

            public Criteria andTypeMemoEqualTo(String value) {
                addCriterion("type_memo =", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoNotEqualTo(String value) {
                addCriterion("type_memo <>", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoGreaterThan(String value) {
                addCriterion("type_memo >", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoGreaterThanOrEqualTo(String value) {
                addCriterion("type_memo >=", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoLessThan(String value) {
                addCriterion("type_memo <", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoLessThanOrEqualTo(String value) {
                addCriterion("type_memo <=", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoLike(String value) {
                addCriterion("type_memo like", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoNotLike(String value) {
                addCriterion("type_memo not like", value, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoIn(List<String> values) {
                addCriterion("type_memo in", values, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoNotIn(List<String> values) {
                addCriterion("type_memo not in", values, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoBetween(String value1, String value2) {
                addCriterion("type_memo between", value1, value2, "typeMemo");
                return (Criteria) this;
            }

            public Criteria andTypeMemoNotBetween(String value1, String value2) {
                addCriterion("type_memo not between", value1, value2, "typeMemo");
                return (Criteria) this;
            }

        
            public Criteria andTargetIdIsNull() {
                addCriterion("target_id is null");
                return (Criteria) this;
            }

            public Criteria andTargetIdIsNotNull() {
                addCriterion("target_id is not null");
                return (Criteria) this;
            }

            public Criteria andTargetIdEqualTo(String value) {
                addCriterion("target_id =", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdNotEqualTo(String value) {
                addCriterion("target_id <>", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdGreaterThan(String value) {
                addCriterion("target_id >", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdGreaterThanOrEqualTo(String value) {
                addCriterion("target_id >=", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdLessThan(String value) {
                addCriterion("target_id <", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdLessThanOrEqualTo(String value) {
                addCriterion("target_id <=", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdLike(String value) {
                addCriterion("target_id like", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdNotLike(String value) {
                addCriterion("target_id not like", value, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdIn(List<String> values) {
                addCriterion("target_id in", values, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdNotIn(List<String> values) {
                addCriterion("target_id not in", values, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdBetween(String value1, String value2) {
                addCriterion("target_id between", value1, value2, "targetId");
                return (Criteria) this;
            }

            public Criteria andTargetIdNotBetween(String value1, String value2) {
                addCriterion("target_id not between", value1, value2, "targetId");
                return (Criteria) this;
            }

        
            public Criteria andValueIsNull() {
                addCriterion("value is null");
                return (Criteria) this;
            }

            public Criteria andValueIsNotNull() {
                addCriterion("value is not null");
                return (Criteria) this;
            }

            public Criteria andValueEqualTo(String value) {
                addCriterion("value =", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotEqualTo(String value) {
                addCriterion("value <>", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueGreaterThan(String value) {
                addCriterion("value >", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueGreaterThanOrEqualTo(String value) {
                addCriterion("value >=", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueLessThan(String value) {
                addCriterion("value <", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueLessThanOrEqualTo(String value) {
                addCriterion("value <=", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueLike(String value) {
                addCriterion("value like", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotLike(String value) {
                addCriterion("value not like", value, "value");
                return (Criteria) this;
            }

            public Criteria andValueIn(List<String> values) {
                addCriterion("value in", values, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotIn(List<String> values) {
                addCriterion("value not in", values, "value");
                return (Criteria) this;
            }

            public Criteria andValueBetween(String value1, String value2) {
                addCriterion("value between", value1, value2, "value");
                return (Criteria) this;
            }

            public Criteria andValueNotBetween(String value1, String value2) {
                addCriterion("value not between", value1, value2, "value");
                return (Criteria) this;
            }

        
            public Criteria andUnitIsNull() {
                addCriterion("unit is null");
                return (Criteria) this;
            }

            public Criteria andUnitIsNotNull() {
                addCriterion("unit is not null");
                return (Criteria) this;
            }

            public Criteria andUnitEqualTo(String value) {
                addCriterion("unit =", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitNotEqualTo(String value) {
                addCriterion("unit <>", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitGreaterThan(String value) {
                addCriterion("unit >", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitGreaterThanOrEqualTo(String value) {
                addCriterion("unit >=", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitLessThan(String value) {
                addCriterion("unit <", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitLessThanOrEqualTo(String value) {
                addCriterion("unit <=", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitLike(String value) {
                addCriterion("unit like", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitNotLike(String value) {
                addCriterion("unit not like", value, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitIn(List<String> values) {
                addCriterion("unit in", values, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitNotIn(List<String> values) {
                addCriterion("unit not in", values, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitBetween(String value1, String value2) {
                addCriterion("unit between", value1, value2, "unit");
                return (Criteria) this;
            }

            public Criteria andUnitNotBetween(String value1, String value2) {
                addCriterion("unit not between", value1, value2, "unit");
                return (Criteria) this;
            }

        
            public Criteria andCreateTimeIsNull() {
                addCriterion("create_time is null");
                return (Criteria) this;
            }

            public Criteria andCreateTimeIsNotNull() {
                addCriterion("create_time is not null");
                return (Criteria) this;
            }

            public Criteria andCreateTimeEqualTo(Date value) {
                addCriterion("create_time =", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeNotEqualTo(Date value) {
                addCriterion("create_time <>", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeGreaterThan(Date value) {
                addCriterion("create_time >", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
                addCriterion("create_time >=", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeLessThan(Date value) {
                addCriterion("create_time <", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
                addCriterion("create_time <=", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeLike(Date value) {
                addCriterion("create_time like", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeNotLike(Date value) {
                addCriterion("create_time not like", value, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeIn(List<Date> values) {
                addCriterion("create_time in", values, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeNotIn(List<Date> values) {
                addCriterion("create_time not in", values, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeBetween(Date value1, Date value2) {
                addCriterion("create_time between", value1, value2, "createTime");
                return (Criteria) this;
            }

            public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
                addCriterion("create_time not between", value1, value2, "createTime");
                return (Criteria) this;
            }

        
            public Criteria andIstransferIsNull() {
                addCriterion("istransfer is null");
                return (Criteria) this;
            }

            public Criteria andIstransferIsNotNull() {
                addCriterion("istransfer is not null");
                return (Criteria) this;
            }

            public Criteria andIstransferEqualTo(String value) {
                addCriterion("istransfer =", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferNotEqualTo(String value) {
                addCriterion("istransfer <>", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferGreaterThan(String value) {
                addCriterion("istransfer >", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferGreaterThanOrEqualTo(String value) {
                addCriterion("istransfer >=", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferLessThan(String value) {
                addCriterion("istransfer <", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferLessThanOrEqualTo(String value) {
                addCriterion("istransfer <=", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferLike(String value) {
                addCriterion("istransfer like", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferNotLike(String value) {
                addCriterion("istransfer not like", value, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferIn(List<String> values) {
                addCriterion("istransfer in", values, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferNotIn(List<String> values) {
                addCriterion("istransfer not in", values, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferBetween(String value1, String value2) {
                addCriterion("istransfer between", value1, value2, "istransfer");
                return (Criteria) this;
            }

            public Criteria andIstransferNotBetween(String value1, String value2) {
                addCriterion("istransfer not between", value1, value2, "istransfer");
                return (Criteria) this;
            }

        
            public Criteria andTransferTimeIsNull() {
                addCriterion("transfer_time is null");
                return (Criteria) this;
            }

            public Criteria andTransferTimeIsNotNull() {
                addCriterion("transfer_time is not null");
                return (Criteria) this;
            }

            public Criteria andTransferTimeEqualTo(Date value) {
                addCriterion("transfer_time =", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeNotEqualTo(Date value) {
                addCriterion("transfer_time <>", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeGreaterThan(Date value) {
                addCriterion("transfer_time >", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeGreaterThanOrEqualTo(Date value) {
                addCriterion("transfer_time >=", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeLessThan(Date value) {
                addCriterion("transfer_time <", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeLessThanOrEqualTo(Date value) {
                addCriterion("transfer_time <=", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeLike(Date value) {
                addCriterion("transfer_time like", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeNotLike(Date value) {
                addCriterion("transfer_time not like", value, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeIn(List<Date> values) {
                addCriterion("transfer_time in", values, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeNotIn(List<Date> values) {
                addCriterion("transfer_time not in", values, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeBetween(Date value1, Date value2) {
                addCriterion("transfer_time between", value1, value2, "transferTime");
                return (Criteria) this;
            }

            public Criteria andTransferTimeNotBetween(Date value1, Date value2) {
                addCriterion("transfer_time not between", value1, value2, "transferTime");
                return (Criteria) this;
            }

        
        public Criteria andLikeQuery(AutoOriimport record) {
            List<String> list = new ArrayList<String>();
            List<String> list2 = new ArrayList<String>();
            StringBuffer buffer = new StringBuffer();
                            if (record.getId() != null && StrUtil.isNotEmpty(record.getId().toString())) {
                    list.add("ifnull(id,'')");
                }
                            if (record.getSupplyId() != null && StrUtil.isNotEmpty(record.getSupplyId().toString())) {
                    list.add("ifnull(supply_id,'')");
                }
                            if (record.getSupplyName() != null && StrUtil.isNotEmpty(record.getSupplyName().toString())) {
                    list.add("ifnull(supply_name,'')");
                }
                            if (record.getSubcompanyId() != null && StrUtil.isNotEmpty(record.getSubcompanyId().toString())) {
                    list.add("ifnull(subcompany_id,'')");
                }
                            if (record.getSubcompanyName() != null && StrUtil.isNotEmpty(record.getSubcompanyName().toString())) {
                    list.add("ifnull(subcompany_name,'')");
                }
                            if (record.getTaskmonth() != null && StrUtil.isNotEmpty(record.getTaskmonth().toString())) {
                    list.add("ifnull(taskmonth,'')");
                }
                            if (record.getTypeMemo() != null && StrUtil.isNotEmpty(record.getTypeMemo().toString())) {
                    list.add("ifnull(type_memo,'')");
                }
                            if (record.getTargetId() != null && StrUtil.isNotEmpty(record.getTargetId().toString())) {
                    list.add("ifnull(target_id,'')");
                }
                            if (record.getValue() != null && StrUtil.isNotEmpty(record.getValue().toString())) {
                    list.add("ifnull(value,'')");
                }
                            if (record.getUnit() != null && StrUtil.isNotEmpty(record.getUnit().toString())) {
                    list.add("ifnull(unit,'')");
                }
                            if (record.getCreateTime() != null && StrUtil.isNotEmpty(record.getCreateTime().toString())) {
                    list.add("ifnull(create_time,'')");
                }
                            if (record.getIstransfer() != null && StrUtil.isNotEmpty(record.getIstransfer().toString())) {
                    list.add("ifnull(istransfer,'')");
                }
                            if (record.getTransferTime() != null && StrUtil.isNotEmpty(record.getTransferTime().toString())) {
                    list.add("ifnull(transfer_time,'')");
                }
                                        if (record.getId() != null && StrUtil.isNotEmpty(record.getId().toString())) {
                    list2.add("'%" + record.getId() + "%'");
                }
                            if (record.getSupplyId() != null && StrUtil.isNotEmpty(record.getSupplyId().toString())) {
                    list2.add("'%" + record.getSupplyId() + "%'");
                }
                            if (record.getSupplyName() != null && StrUtil.isNotEmpty(record.getSupplyName().toString())) {
                    list2.add("'%" + record.getSupplyName() + "%'");
                }
                            if (record.getSubcompanyId() != null && StrUtil.isNotEmpty(record.getSubcompanyId().toString())) {
                    list2.add("" + record.getSubcompanyId() + "");
                }
                            if (record.getSubcompanyName() != null && StrUtil.isNotEmpty(record.getSubcompanyName().toString())) {
                    list2.add("'%" + record.getSubcompanyName() + "%'");
                }
                            if (record.getTaskmonth() != null && StrUtil.isNotEmpty(record.getTaskmonth().toString())) {

                    list2.add("" + record.getTaskmonth().replace("-","") + "");
                }
                            if (record.getTypeMemo() != null && StrUtil.isNotEmpty(record.getTypeMemo().toString())) {
                    list2.add("'%" + record.getTypeMemo() + "%'");
                }
                            if (record.getTargetId() != null && StrUtil.isNotEmpty(record.getTargetId().toString())) {
                    list2.add("'%" + record.getTargetId() + "%'");
                }
                            if (record.getValue() != null && StrUtil.isNotEmpty(record.getValue().toString())) {
                    list2.add("'%" + record.getValue() + "%'");
                }
                            if (record.getUnit() != null && StrUtil.isNotEmpty(record.getUnit().toString())) {
                    list2.add("'%" + record.getUnit() + "%'");
                }
                            if (record.getCreateTime() != null && StrUtil.isNotEmpty(record.getCreateTime().toString())) {
                    list2.add("'%" + record.getCreateTime() + "%'");
                }
                            if (record.getIstransfer() != null && StrUtil.isNotEmpty(record.getIstransfer().toString())) {
                    list2.add("'%" + record.getIstransfer() + "%'");
                }
                            if (record.getTransferTime() != null && StrUtil.isNotEmpty(record.getTransferTime().toString())) {
                    list2.add("'%" + record.getTransferTime() + "%'");
                }
                        buffer.append(" CONCAT(");
            buffer.append(StrUtil.join(",", list));
            buffer.append(")");
            buffer.append(" like CONCAT(");
            buffer.append(StrUtil.join(",", list2));
            buffer.append(")");
            if (!" CONCAT() like CONCAT()".equals(buffer.toString())) {
                addCriterion(buffer.toString());
            }
            return (Criteria) this;
        }

        public Criteria andLikeQuery2(String searchText) {
            List<String> list = new ArrayList<String>();
            StringBuffer buffer = new StringBuffer();
                            list.add("ifnull(id,'')");
                            list.add("ifnull(supply_id,'')");
                            list.add("ifnull(supply_name,'')");
                            list.add("ifnull(subcompany_id,'')");
                            list.add("ifnull(subcompany_name,'')");
                            list.add("ifnull(taskmonth,'')");
                            list.add("ifnull(type_memo,'')");
                            list.add("ifnull(target_id,'')");
                            list.add("ifnull(value,'')");
                            list.add("ifnull(unit,'')");
                            list.add("ifnull(create_time,'')");
                            list.add("ifnull(istransfer,'')");
                            list.add("ifnull(transfer_time,'')");
                        buffer.append(" CONCAT(");
            buffer.append(StrUtil.join(",", list));
            buffer.append(")");
            buffer.append("like '%");
            buffer.append(searchText);
            buffer.append("%'");
            addCriterion(buffer.toString());
            return (Criteria) this;
        }

    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}